package com.diliuzun.delivery.mapper;

import com.diliuzun.delivery.entity.vo.UserVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.ArrayList;

@Mapper
public interface UserAnalysisMapper {

    @Select("select sex,count(*) as count from user group by sex")
    ArrayList<UserVo>  getUserDataBySex();

    @Select("select yhsf,count(*) as count from user group by yhsf")
    ArrayList<UserVo> getUserDataByType();
}
